Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology by Unknown

Author:Unknown
Language: eng
Format: epub
Publisher: Packt Publishing

There's more...

Oracle has published a white paper—Best Practices for a Data Warehouse on Oracle Database 11g, An Oracle White Paper, November 2010. This has a lot of information with regards to Dimensional (Star) modeling and Third Normal Form.

The white paper can be found at the following web address:

http://www.oracle.com/technetwork/database/bi-datawarehousing/twp-dw-best-practies-11g11-2008-09-132076.pdf.

Chapter 8. Analyzing the Sources

Identifying the right information from the correct source is the key to the success and reputation of the business intelligence and data warehouse project. There can potentially be many different sources for the same information within the organization. If an incorrect source for information is chosen, the level of trust and acceptance for the project will be decreased greatly. This chapter outlines how to analyze data sources to gain a deeper understanding of the information, and how it maps to the requirements and the data model. The recipes help to define the road map of information and how it is used with the project:

Validating and enhancing a conceptual data model

Creating a business process matrix

Creating a report requirements matrix

Creating a source matrix

Developing the data lineage

Defining the detailed transformations

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.